SELECT
    products.p_id,
    products.p_name,
    products.p_type,
    products.p_code,
    products.category_id,
    categorys.category_slug,
    taxrates.code_name AS taxrate_code_name,
    suppliers.code_name,
    product_to_store.purchase_price,
    product_to_store.sell_price,
    
    
    
FROM
    products
JOIN
    product_to_store ON products.p_id = product_to_store.product_id
JOIN
    suppliers ON product_to_store.sup_id = suppliers.sup_id
JOIN
    taxrates ON product_to_store.taxrate_id = taxrates.taxrate_id
JOIN
    categorys ON products.category_id = categorys.category_id
WHERE
    product_to_store.sup_id = 56;

4404 rem con este

3046
2435
2464
3242